<?php
defined('ROOTPATH') OR exit('No direct script access allowed');
/**
 * TestModel
 */
class TestModel extends BaseModel
{
    public function getOne($id)
    {
        $sql = 'SELECT * FROM `user_account` where `user_id` = '.$id.' limit 0, 1';
        $result = $this->query($sql, 1);
        
        return $result;
    }

    public function getAll()
    {
        $sql = 'SELECT * FROM `user_account`';
        $result = $this->query($sql);
        
        return $result;
    }

    public function exec($id)
    {
        $sql = 'update `user_account` set `status` = 0 where `user_id` = '.$id;
        $result = $this->execute($sql);
        
        return $result;
    }
}
